--
-- MySQL 5.5.24
-- Sun, 03 Feb 2013 04:12:48 +0000
--

CREATE TABLE `WEATHER_SHANGHAI` (
   `ID` int(11) not null auto_increment,
   `TYPE` int(11),
   `CONTENT` text,
   `CREATE_TIME` timestamp not null default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
   PRIMARY KEY (`ID`),
   KEY `TYPE` (`TYPE`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

-- [Table `WEATHER_SHANGHAI` is empty]